This option allows you to rename an SQL table:
To rename an SQL table, proceed as follows:
Select option 6 from the main menu. You will be prompted:
Define Tablename to be Processed… Enter Tablename :
Enter the name of the SQL table you wish to rename. If you enter
?, a
list of tables is displayed, from which you can select. See
Using the SQLM Menu Options.
You will then be prompted:
Enter alternative Table name for Rename action... Enter Tablename :
Enter the new name for the table. When you press RETURN, the table will be renamed and this will be confirmed by the message:
SQL table Renamed. Enter <CR>:
Press RETURN to redisplay the main menu.